package com.tedu.egmybatis2.mapper;

import com.tedu.egmybatis2.pojo.Customers;
import com.tedu.egmybatis2.pojo.CustomersVO1;
import com.tedu.egmybatis2.pojo.CustomersVO2;
import com.tedu.egmybatis2.pojo.CustomersVO3;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface CustomersMapper {
    int insertCustomers(Customers customers);

    CustomersVO1 selectCustomerVO1ById(String id);

    List<CustomersVO2> selectCustomerVO2ByCity(String city);

    List<CustomersVO3> selectCustomerVO3AndOrdersVO1ByCustId(String id);
}
